﻿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!--DXMETADATA start type="MetaCharset" --><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><!--DXMETADATA end-->
    <meta http-equiv="X-UA-Compatible" value="IE=9" />

    <!--DXMETADATA start type="Literal" condition="helpversion:value=3" value="<meta name=""Microsoft.Help.SelfBranded"" content=""true"" />" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<title>%%ProjectTitle%% - %%ItemTitle%%</title>" --><title>SpreadJS ReadMe - Release Notes for Version 13.0.0</title><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<meta name=""Title"" content=""%%ProjectTitle%% - %%ItemTitleNoQuotes%%""/>" --><meta name="Title" content="SpreadJS ReadMe - Release Notes for Version 13.0.0"/><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="jquery" filetype="script" firstlinkattributes="id=""mshs_support_script"""--><script src="template/packages/jquery/script/default/jquery-1.11.3.min.js" type="text/javascript" id="mshs_support_script"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="script"--><script src="template/packages/jquery-ui/script/default/jquery-ui-1.11.4.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/jquery-ui/css/default/jquery-ui-1.11.4.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="TemplateSettingsJson" format="<script type=""text/javascript"">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:%%TemplateSettingsJson%%});</script>" --><script type="text/javascript">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:{"dynamictoc":{"initialNodeId":"n3","initialNodeContainer":"c0","isResizable":true},"inthistopic":{"isEnabled":true},"currentLocale":"-","isFrameless":true,"navigationKind":"inpage","versions":{"locale":{"currentId":"-"}}}});</script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="light" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/light/css/dynamic-toc.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="Synopsis" StripHtmlTags="True" MaxLength="250" format="<meta name=""Description"" content=""%%Synopsis%%"" />"--><meta name="Description" content="Enhancements from the Previous Release

The following features have been added with this version of the product." /><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/plugins-topics/css/default/jquery-plugins.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="css" firstlinkattributes=" data-mshv2-stylesheet=""/template/packages/core-topics/topics.mshv2.css"" data-mshv1-stylesheet=""/template/packages/core-topics/topics.mshv1.css"" data-responsive-mobile=""template/packages/core-topics/topics.mobile.css"" data-responsive-tablet=""template/packages/core-topics/topics.tablet.css"""--><link rel="stylesheet" type="text/css" href="template/packages/core-topics/css/topics.css"  data-mshv2-stylesheet="/template/packages/core-topics/topics.mshv2.css" data-mshv1-stylesheet="/template/packages/core-topics/topics.mshv1.css" data-responsive-mobile="template/packages/core-topics/topics.mobile.css" data-responsive-tablet="template/packages/core-topics/topics.tablet.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="script"--><script src="template/packages/plugins-topics/script/default/jquery-plugins.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="script"--><script src="template/packages/core-topics/script/topics.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="TopicId" format="<meta name=""Microsoft.Help.Id"" content=""%%TopicId%%""/>" --><meta name="Microsoft.Help.Id" content="333db5ae-4907-471a-bf39-14504b4f5ef9"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocParentId" format="<meta name=""Microsoft.Help.TocParent"" content=""%%TocParentId%%""/>" --><meta name="Microsoft.Help.TocParent" content="80753e0a-efcf-407b-89ce-337c2fd3b27e"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocOrdinal" format="<meta name=""Microsoft.Help.TocOrder"" content=""%%TocOrdinal%%""/>" --><meta name="Microsoft.Help.TocOrder" content="1"/><!--DXMETADATA end-->
    <meta name="Microsoft.Help.F1" content=""/>
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <!--DXMETADATA start type="MshvKeywords" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="MshvMetaTags" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.Locale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.TopicLocale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Stylesheets" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="StylePropertyValues" format="<style>%%StylePropertyValues%%</style>" --><style>.i-is-new .i-page-title-text::after, ul#i-dt-root li.i-is-new>a::after { content: "New" }
</style><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scripts" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="DesignTime"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end -->
    <!--DXMETADATA start type="CustomHeadContent" --><link rel="stylesheet" type="text/css" href="template/packages/core-web/css/SP.css">
<script type="text/javascript">
var currentHeader = function() {
    return "spjsreadme";
}
</script>
<script src="template/packages/core-web/script/topNavigation.js"></script>
<script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-WT462SJ"></script>
<script>
        (function (w, d, s, l, i) {
            w[l] = w[l] || [];
            w[l].push({
                'gtm.start': new Date().getTime()
                , event: 'gtm.js'
            });
            var f = d.getElementsByTagName(s)[0]
                , j = d.createElement(s)
                , dl = l != 'dataLayer' ? '&l=' + l : '';
            j.async = true;
            j.src = 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
            f.parentNode.insertBefore(j, f);
        })(window, document, 'script', 'dataLayer', 'GTM-WT462SJ');
    </script>

<!--DXMETADATA end-->
</head>

<body>
    <div id="i-before-header-content" class="i-before-header-content">
        
    </div>

    <div id="i-header-container">
        <div id="i-header-content" class="i-header-content i-content-width-container">
            <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end-->
            <div class="i-project-title"><!--DXMETADATA start type="ProjectTitle" -->SpreadJS ReadMe<!--DXMETADATA end--></div>
            <div class="i-search-container">
                <!--DXMETADATA start type="outputfileextension" format="<form action=""websearch%%outputfileextension%%"">" --><form action="websearch.html"><!--DXMETADATA end-->
                <input id="i-search" name="query"/>
                <input type="submit" id="i-search-button" value=""/>
                <!--DXMETADATA start type="Literal" value="</form>" --></form><!--DXMETADATA end-->
            </div>
            <!--DXMETADATA start type="outputfileextension" format="<a id=""i-index-button"" href=""webindex%%outputfileextension%%""></a>" --><a id="i-index-button" href="webindex.html"></a><!--DXMETADATA end-->
        </div>
    </div>
    
    <div class="i-content-width-container"><div class="i-busy-overlay"></div></div>

    <div id="i-breadcrumbs-outer-container" class="i-content-width-container"><!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="i-breadcrumbs-container">
<a href="readme.html">ReadMe</a>
 / <a href="rnotes.html">Release Notes</a>
 / Release Notes for Version 13.0.0</div><!--DXMETADATA end --></div>

    

    <div id="i-actions-outer-container" class="i-content-width-container">
        <div id="i-actions-container">
            <div id="i-actions-content" class="i-fixed-to-top">
                <!-- Spacing --> <span class="i-toggle-all-sections i-function-link">
                <label class="i-collapse-all"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label>
                <label class="i-expand-all" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label>
            </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end -->
                <div class="i-in-this-topic-container">
                    <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
                </div>
            </div>
        </div>
    </div>

    <div id="i-toc-outer-container" class="i-content-width-container">
        <div id="i-toc-container">
            <div id="i-toc-content" class="i-fixed-to-top">
                <div class="i-toc-content-scroll-container">
                    <div id="i-dynamic-toc-container"><ul id="i-dt-root"></ul></div>
                </div>
            </div>
        </div>
    </div>

    <div id="i-body-content-container" class="i-content-width-container">
        <div id="i-body-content" class="i-body-content">
            <div class="i-page-title"><div class="i-page-title-text"><!--DXMETADATA start type="ItemTitle" -->Release Notes for Version 13.0.0<!--DXMETADATA end--></div></div>
            <div class="i-in-this-topic-container">
                <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
            </div>
            <!--DXMETADATA start type="TopicSection" name="BodyText"--><h1>Enhancements from the Previous Release</h1>

<p>The following features have been added with this version of the product.</p>

<ul>
    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/check-box-list-cell.html" target="_blank">Checkbox list celltype</a> is now supported to allow users to create interactive checklists&nbsp;and to-do lists with multi selecttion field values.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/radio-button-list-cell.html" target="_blank">Radio button list celltype</a> is now supported to provide users with the ability to choose and select a single item from a list of several options available within a cell in the worksheet.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/button-list-cell.html" target="_blank">Button list celltype</a> is now supported to allow users to embed a group of items within a single cell where one or multiple options can be selected to record user responses.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/range-template-cell.html" target="_blank">Range template celltype</a> is now supported to enable users to define a template of cell ranges as a single celltype and apply that template to one or more cells across the worksheet.</li>

    <li>Users can configure custom cell styles when different&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/cell-states.html" target="_blank">Cell States</a> (like edit, hover, active, select etc)&nbsp;are matched in a worksheet.</li>

    <li>Support for&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/cell-buttons.html" target="_blank">Cell Buttons</a> (predefined buttons like drop-down buttons, undo/redo buttons, enable/disable buttons, spin buttons etc.)&nbsp;is now provided to allow users to configure additional functionalities in the cells of the worksheet.</li>

    <li>Users can select data easily and quickly using the&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/cell-dropdowns.html" target="_blank">Cell Dropdowns</a> feature that inserts a custom drop down menu with specific properties for creating advanced input forms and interactive dashboards.</li>

    <li>The&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/auto-merge-cells.html" target="_blank">Auto Merge</a> feature has been introduced in order to allow&nbsp;users to automatically merge the neighboring cells containing duplicate text.</li>

    <li>Support for&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/formula-auditing.html" target="_blank">Formula Auditing</a> has been provided to&nbsp;allow users to display relationships between formulas and cells by tracing the precedent and dependent cells in the worksheet.</li>

    <li>Users can work with&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/dynamic-array-formulas.html" target="_blank">dynamic array formulas</a> (<a href="https://www.grapecity.com/spreadjs/docs/v13/online/unique.html" target="_blank">UNIQUE</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/filter-dynamic-array.html" target="_blank">FILTER</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/randarray.html" target="_blank">RANDARRAY</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/sort.html" target="_blank">SORT</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/sortby.html" target="_blank">SORTBY</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/sequence.html" target="_blank">SEQUENCE</a> function,&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/single.html" target="_blank">SINGLE</a> function etc.) to build cache-friendly data structures.</li>

    <li>The&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/split-resize-columns-and-rows.html" target="_blank">Split Resize</a> feature has been introduced to&nbsp;allow users to resize the current row or column along with the next visible column or row without affecting the the remaining rows and columns in the worksheet.&nbsp;</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/dynamic-column-size.html" target="_blank">Dynamic Column sizing</a> is now supported to allow users to configure the column widths&nbsp;and row heights in such a way that the viewport is filled exactly as per the weighted proportion (* symbol) specified by the user.</li>

    <li>The&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/scroll-by-pixel.html" target="_blank">Scroll by Pixel</a> feature has been introduced to provide support for&nbsp;Excel-like precision scrolling.</li>

    <li>Now, users can&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/rotate-text-in-cells.html" target="_blank">rotate text in cells</a> (from -90 to + 90 degrees)&nbsp;to change the way data appears in a cell.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/ConfiguringLegends.html" target="_blank">Custom Legend Formatting, Positioning and Styling</a> is now supported while working with legends in the charts.</li>

    <li>Users can&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/ConfiguringAxes.html" target="_blank">configure display units on value axis</a> while working with charts&nbsp;in the spreadsheets.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/add-trendlines-to-charts.html" target="_blank">Adding Trendlines to charts</a> is now supported in order to enable users to quickly analyze the overall trends (ups and downs in the data points), show data movements over a period of time or simply correlate two different variables.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/add-error-bars-in-charts.html" target="_blank">Adding Error Bars in charts</a> is now supported to allow users to identify margins of error, standard deviations and showcase data variability along with measurement accuracy&nbsp;etc.</li>

    <li>Users can&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/add-hover-animation-and-style.html" target="_blank">add hover animation and style</a> to allow users to interact with the data points in the chart.</li>

    <li>Users can&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/change-vertical-axis-to-logarithmic-scale.html" target="_blank">change vertical axis to logarithmic scale</a> to allow users to customize the minimum and the maximum scale values of the vertical axis (also called value axis).</li>

    <li>Users can&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/display-empty-cells-in-chart.html" target="_blank">display empty cells and null values in charts</a> just like in Excel. This feature is helpful in plotting the missing data in a chart, quickly identifying and correcting any issues with the data.</li>

    <li><a href="https://www.grapecity.com/spreadjs/docs/v13/online/chart-area.html" target="_blank">Customization of chart area border</a> is now supported.</li>

    <li>Now, SpreadJS&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/spdesigneropen.html" target="_blank">remembers the sheet view position</a>&nbsp;just like in Excel&nbsp;whenever a workbook is saved.</li>

    <li>The&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/agrregate.html" target="_blank">AGGREGATE</a> function is now supported just like in Excel.</li>

    <li>New theme "<a href="https://www.grapecity.com/spreadjs/docs/v13/online/exceltheme.html" target="_blank">Excel 2016 Black</a>" has been introduced in this version.</li>

    <li>Table UI enhancements - The following UI enhancements&nbsp;have been introduced while working with tables in spreadsheets:&nbsp;

        <ul>
            <li>The "Auto expand table area" feature&nbsp;is now supported.&nbsp;While working in SpreadJS Designer, users can&nbsp;input data&nbsp;in the next row or the column next to the table area, and the table will be automatically expanded. When users&nbsp;perform the&nbsp;cut, copy, paste operations, the drag fill operations (towards right direction or downwards direction) or the drag drop operation, if the paste area exceeds the range of the table, then also the&nbsp;table will be automatically expanded.&nbsp;</li>

            <li>Now, table columns and rows&nbsp;can be inserted and deleted through the built-in context menu in the&nbsp;SpreadJS Designer.&nbsp;</li>

            <li>Now, users can select a table column, row or the entire table via moving cursors at multiple positions in the worksheet. For example - users can select a table column by hovering over the top edge of the table column header until the cursor changes to the down arrow and then the header can be clicked to select the table column. Users can also&nbsp;select the row or top-left corner of the table to select the table.</li>

            <li>Users can use either&nbsp;the "TAB key" or "Shift+TAB" key to quickly switch between the&nbsp;cells in the table or expand the table range.</li>

            <li>With the newly introduced "Fixed scrolling table headers" feature, the table headers&nbsp;can be displayed in the column header when users scroll the table data and the table header is out of the worksheet's visible area.</li>
        </ul>
    </li>

    <li>While working with tables,&nbsp;users can add a "total row" just like in Excel. The total row formulas are also supported&nbsp;to allow users to quickly&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/tablestyle.html" target="_blank">display the table footer dropdown</a> and&nbsp;select the dropdown list to choose and insert the desired summary function.</li>

    <li>Now, users can easily&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/resize-tables.html" target="_blank">resize tables</a> using the table resizing handler.&nbsp;</li>

    <li>Advanced column binding features are supported to allow users to&nbsp;<a href="https://www.grapecity.com/spreadjs/docs/v13/online/tablebind.html" target="_blank">bind formatter and celltypes to table columns</a>.</li>
</ul>

<h1>Resolved Issues</h1>

<p>The following issues have been resolved since the last release.</p>

<ul>
    <li>The formula calculation results&nbsp;are now accurate upto utmost precision.&nbsp;</li>

    <li>The result of performing an auto row height operation via double clicking the row&nbsp;is now accurate.</li>

    <li>No content errors are displayed while importing the excel files.</li>

    <li>When the cell contains multiline text and the "Ctrl+Z" keyboard shortcut is used in edit mode, then no DOMException is thrown now.</li>

    <li>The STDEVA formula now calculates correct results.</li>

    <li>No styles are missed while&nbsp;exporting&nbsp;the SSJSON file to&nbsp;Excel.&nbsp;</li>

    <li>No #Value errors are thrown while calculating functions after importing the Excel file.</li>

    <li>Now, Excel files can be&nbsp;imported with SpreadJS without any issues.</li>

    <li>While working with SpreadJS in Chinese IME the symbol "=" can now be entered in the cells without going into the edit mode.</li>

    <li>The wordwrap feature in SpreadJS now works in the same way as in Excel.</li>

    <li>Now, forms can be deleted normally without any issues. The error "Cannot read property 'getRowCount' of null" is not thrown now.</li>

    <li>While importing Excel files into SpreadJS, the original border is not lost now .</li>

    <li>While exporting to a PDF file, the border remains intact and doesn't get narrowed.</li>

    <li>No errors are thrown when hidden forms are displayed&nbsp;again&nbsp;using sheet.visible() method.</li>

    <li>Now, the floating point precision problems have been resolved and no calculation errors are thrown while calculating the ROUND function.</li>

    <li>Now, SpreadJS performance is consistent on all operating systems including&nbsp;MAC, Linux, and Windows (Chrome 67).&nbsp;</li>

    <li>The position of the shapes embedded&nbsp;in the worksheet remains intact even when the "zoom" of the worksheet is changed.</li>

    <li>While working with charts, gridlines and labels on the right side&nbsp;are displayed without any issues.</li>

    <li>Now, users can set the scale interval of x-axis while working with charts.</li>

    <li>Different chart types can be displayed in the same legend area now. Also, users can modify the chart line type of the legends in the chart.</li>

    <li>When the formula parameter is a specific string, now the parameter will not change&nbsp;automatically, and the operation of selecting the cell will not cause any errors.</li>

    <li>Now, no erros are thrown after deleting the worksheet.</li>

    <li>The result of the formula execution in SpreadJS now works in the same way as in Excel.</li>

    <li>While importing Excel files in SpreadJS, the style of the chart title remains intact.</li>

    <li>After disabling the shape resize feature, the shape resizing cursor is not displayed now.</li>

    <li>While using fallback fonts, there is no effect on the performance of the&nbsp;export to PDF operation now.</li>

    <li>The scrolling now works faster with thousands of rows&nbsp;(50,000 rows) bound in a table.</li>

    <li>Another shape below the clicked shapes is not selected unexpectedly now.</li>

    <li>No errors are thrown while working with QR code in the spreadsheets.</li>

    <li>The Chart menu of the SJS Designer now works properly without any issues.</li>

    <li>The import operation now takes comparatively less time and works much&nbsp;faster than before.</li>

    <li>Custom cell styles now work as expected.</li>

    <li>Upon opening the exported Excel file, now users can recover the warning messages without any hassle.</li>

    <li>While exporting Excel files, the column bar doesn't get overlapped if the secondary axis is set.</li>

    <li>When users right click on the spreadsheet, now the context menu for the shape works as expected and&nbsp;is not shown if the shape is hidden.</li>

    <li>The imported Excel file now displays the correct format.</li>

    <li>The data source of the chart is now highlighted correctly if the source is split via commas.</li>

    <li>If a workbook contains SUBTOTAL formula and the workbook is destroyed as a result of routing to another page or due to false condition for *ngIF then the error "TypeError: Cannot read property 'getRowCount' of null" error is not thrown now.</li>

    <li>The drag fill operation for the filtered rows&nbsp;now works just like in Excel without any issues.</li>

    <li>Now, users can correctly import the Excel file that contains cross workbook formula references.</li>

    <li>Now, users can easily copy paste the line break content using formula textbox.</li>

    <li>Zooming of shapes now works correctly without any issues.</li>

    <li>Now the Excel file is exported correctly even when multiple files are exported in a loop.</li>

    <li>The SMALL formula now works in the same way as in Excel.</li>

    <li>Charts can now be rendered for specific height values without any issue.</li>

    <li>The Filter dialog now&nbsp;displays instantly when the conditional format is set by the user.</li>
</ul><!--DXMETADATA end-->
            <a name="seealsobookmark"></a>
            <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><!--DXMETADATA end-->
            
            <div id="i-footer-content" class="i-footer-content">
                <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p>&nbsp;</p><p>&nbsp;</p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p>&nbsp;</p><p>&nbsp;</p><hr style="height: 1px" /><p><p>Copyright © 2019 GrapeCity, Inc. All rights reserved.</p>
<p><a href="https://www.grapecity.com/forums/spread-sheets" target="_blank">Product Support Forum</a> | <a href="javascript:window.print()">Print this page</a></p>
<ul class="social">
<li><a href="https://www.facebook.com/GrapeCityUS/" target="_blank" class="facebook">&nbsp;</a></li>
<li><a href="https://twitter.com/GrapeCityUS" target="_blank" class="twitter">&nbsp;</a></li>
<li><a href="https://www.linkedin.com/company/grapecity" target="_blank" class="linkedin">&nbsp;</a></li>
</ul>
</p><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end-->
            </div>
        </div>
    </div>
        
    <script type="text/javascript">
        $(function () {
            var documentInstance = new Innovasys.Content.Document(document.body);
            documentInstance.load();
        });
    </script>
</body>
</html>
